create external table jms_dm.dm_outfield_person_order_sum_dt 
(
date_time  date COMMENT '业务日期' ,
pick_staff_code    string COMMENT '取件业务员编码' ,
pick_staff_name  string COMMENT '取件业务员名字' ,
taking_success_sum   bigint COMMENT '揽收成功总量' ,
order_taking_fail_sum   bigint COMMENT '揽收失败总量'
)
comment '星级排名需求（业务员订单揽收情况）'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_outfield_person_order_sum_dt'
TBLPROPERTIES (
 'discover.partitions' = 'false',
   'parquet.column.index.access' = 'true'
   );
